app/src/main/java/ai/pai/lensman/db/DBService.java

@@ -143,10 +143,41 @@ public class DBService {

                         }
              

                     }
              

                 
              

                -    public ArrayList<SessionBean> getSessionBeanListByDay(){
              

                +    public ArrayList<SessionBean> getSessionBeanListByDay(long sessionDate){
              

                         ArrayList<SessionBean> sessionBeanArrayList = new ArrayList<>();
              

                -        //TODO
              

                -
              

                +        SQLiteDatabase db = null;
              

                +        Cursor c = null;
              

                +        synchronized (DB_LOCK) {
              

                +            try {
              

                +                db = dbHelper.getReadableDatabase();
              

                +                db.beginTransaction();
              

                +                c = db.rawQuery("select * from " + DBHelper.PHOTO_INFO_TABLE + " where "
              

                +                        + DBHelper.PHOTO_INFO_COLUMNS.SESSION_DATE + " = '" + sessionDate + "' order by " + DBHelper.PHOTO_INFO_COLUMNS.SESSION_SEQ + " desc", null);
              

                +                while (c.moveToNext()) {
              

                +                    PhotoBean photoBean = cursor2PhotoBean(c);
              

                +                    if(sessionBeanArrayList.size()==0 || sessionBeanArrayList.get(sessionBeanArrayList.size()-1).sessionSeq!=photoBean.sessionSeq){
              

                +                        SessionBean sessionBean = new SessionBean();
              

                +                        sessionBean.sessionDate = photoBean.sessionDate;
              

                +                        sessionBean.sessionSeq = photoBean.sessionSeq;
              

                +                        sessionBean.sessionId = photoBean.sessionId;
              

                +                        ArrayList<PhotoBean> photoList = new ArrayList<>();
              

                +                        sessionBean.sessionPhotos = photoList;
              

                +                        sessionBeanArrayList.add(sessionBean);
              

                +                    }
              

                +                    sessionBeanArrayList.get(sessionBeanArrayList.size()-1).sessionPhotos.add(photoBean);
              

                +                }
              

                +                db.setTransactionSuccessful();
              

                +            } catch (Exception e) {
              

                +                LogHelper.d(TAG, "dbservice getSessionBeanListByDay error happen " + e);
              

                +            } finally {
              

                +                try {
              

                +                    db.endTransaction();
              

                +                } catch (Exception e) {
              

                +                    e.printStackTrace();
              

                +                }
              

                +                closeCursorAndDB(c, db);
              

                +            }
              

                +        }
              

                         return sessionBeanArrayList;
              

                     }